package com.tanhua.dubbo.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tanhua.domain.db.AnalysisByDay;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface AnalysisByDayMapper extends BaseMapper<AnalysisByDay> {

    @Select(" select  sum(num_registered) as num from tb_analysis_by_day ")
    Long queryCumulativeUsers();

    @Select(" select  sum(num_active)  as num from tb_analysis_by_day  where record_date>=#{passStr} and  record_date<=#{todayStr}")
    Long queryActivePass(@Param("todayStr") String todayStr, @Param("passStr") String passStr);
}
